UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6KxiJQapL6tX6wiXFQT+hPqcFprg3yVFWD+WMUVkHc='
WHERE
key_id = '923d6508ee868a753b127bf940e52f52560c6a481e56c0bbf66c0cc23e627076'
AND (
token = 'Z6KxiJQapL6tX6wiXFQT+hPqcFprg3yVFWD+WMUVkHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)