UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HRQHTEXW27t7Drbd2k7MEw8xvGnkXsXm0TihQj4f+3A='
WHERE
key_id = '29ca3bfddac7ce1016621a765971d152cfdd80630f01cc6df4a008e534209c83'
AND (
token = 'HRQHTEXW27t7Drbd2k7MEw8xvGnkXsXm0TihQj4f+3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)