UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Of7HCPBUpb2Yt6pGxbNy5T2gDRat5ezsRZ6vzMkPRaI='
WHERE
key_id = 'ab8a9117e3221509f44c6fa3f35ec38e4b1c345e0f0e861f4c03ed62b6c3d1d5'
AND (
token = 'Of7HCPBUpb2Yt6pGxbNy5T2gDRat5ezsRZ6vzMkPRaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)