UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EyOmPH7lfCL5l41c2I+ckmzDRGdswOc8cgveRyb/uPw='
WHERE
key_id = 'a7b9c838b7d7815f8ad63f56d42e639f57c38e2a8596c39c5314197471466312'
AND (
token = 'EyOmPH7lfCL5l41c2I+ckmzDRGdswOc8cgveRyb/uPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)