UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oWYp2lT8QngDw7WoWSrA5aiZv71U5yh9lnm7Gp5C1bk='
WHERE
key_id = '47434e8f8d8a3eb793839d987d3e1076a5d4f144c13bf4a9e125704bf4eb0bcf'
AND (
token = 'oWYp2lT8QngDw7WoWSrA5aiZv71U5yh9lnm7Gp5C1bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)