UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bkX9E0LbMjoN7ULw3Od1NEhwLFRKyZJWgGiIr+tWO30='
WHERE
key_id = 'c2c52bd63a742fc05cd8337182a8f35588021d8d7aa8728657df204b47bba491'
AND (
token = 'bkX9E0LbMjoN7ULw3Od1NEhwLFRKyZJWgGiIr+tWO30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)