UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0r4bulq61NRS8mHbTH0eRKWAxTWfuDheMB2yp9gQuf4='
WHERE
key_id = 'a9ea55af739381620edab58c037d354a2628c64dea4883005474e6c4b4ee1814'
AND (
token = '0r4bulq61NRS8mHbTH0eRKWAxTWfuDheMB2yp9gQuf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)