UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NGqqImngQHGfDvyT1lGW7pwT6eKPCIqA3sLjUDRy23Q='
WHERE
key_id = '48ff595cefcdffd479f316a705545e4afb0b0ef015ad7071431252e8e6a579ce'
AND (
token = 'NGqqImngQHGfDvyT1lGW7pwT6eKPCIqA3sLjUDRy23Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)