UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UYUG26ZA9JPibPy/WWR9ZYLGGxekdJ/Hlftda8d57lw='
WHERE
key_id = 'dc1ae4949c81cb54690de218943a667a98308c581a0743d1cba7edddf4508121'
AND (
token = 'UYUG26ZA9JPibPy/WWR9ZYLGGxekdJ/Hlftda8d57lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)