UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bq8z9UdQzPperaTqUYrMJuIWibIKEQheg5koqY1xoBY='
WHERE
key_id = '5201c3fb660874c4f6b5b742b7935a4b107e6492654596abfab9b451f03e1234'
AND (
token = 'bq8z9UdQzPperaTqUYrMJuIWibIKEQheg5koqY1xoBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)