UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o4xAEsWaqpvU8YS6YyyjDDoFaxZdPC8mFw2u8t8vur0='
WHERE
key_id = 'fde53b1b0c7ac8507c5efba89ef79404e4818a5454773e448683bb4891021374'
AND (
token = 'o4xAEsWaqpvU8YS6YyyjDDoFaxZdPC8mFw2u8t8vur0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)