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