UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wE7TdTSMe9A9G4MhQxIYFgvSGN3BHeYOq0/j22t6VhU='
WHERE
key_id = '0b467b93bdb4e86ce90cb736ebabfe9af8e95e3d24be4fcbb5e204c3434b1469'
AND (
token = 'wE7TdTSMe9A9G4MhQxIYFgvSGN3BHeYOq0/j22t6VhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)