UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wgNe9CLGa5AvqDsfV+oigKbNMO8n/CpEJFmk2+xWJKY='
WHERE
key_id = 'b9e9ac87147ef638617cf719fdf53f7f05f8dfe0013a6c6478fe3f957be6ace8'
AND (
token = 'wgNe9CLGa5AvqDsfV+oigKbNMO8n/CpEJFmk2+xWJKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)