UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dc7J8ITvVR0As08tVQV4HMypcqPIPghXCR3toeMDr70='
WHERE
key_id = '4a2a784b3a7a9d2f9e65954972c0703a5c3d33d4b5ec7b907ea89cbb667ec8ae'
AND (
token = 'Dc7J8ITvVR0As08tVQV4HMypcqPIPghXCR3toeMDr70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)