UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J3w6FPtL9aQSpDNAXE0kTMI73fnbNcysF4U0hnOo0Rg='
WHERE
key_id = '175bbf30b104aa3a8d28005b6721458b186ea01e29b44fb8269d39063870787b'
AND (
token = 'J3w6FPtL9aQSpDNAXE0kTMI73fnbNcysF4U0hnOo0Rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)