UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NRGlEsBsteHaoAh0BNAkVcOxa76NmgjC2lRqHk4MjMs='
WHERE
key_id = '6ad43f9adafb747d2c6489a4b0d2ce01c1c65e47cbc9acde93c478e302f33fc1'
AND (
token = 'NRGlEsBsteHaoAh0BNAkVcOxa76NmgjC2lRqHk4MjMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)