UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Npt/wo80/NkpFH+JTmeOW4XjSsSgba2cf/AaKJSQoM='
WHERE
key_id = 'cca0660642538d9c45d04ae666a4627d58f01faef6b5eb006cf53e809a18f2de'
AND (
token = '+Npt/wo80/NkpFH+JTmeOW4XjSsSgba2cf/AaKJSQoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)