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