UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y6vWCdlw5cCSLWzYTpWtP0n4TW0sQpbJo/UatB3ziko='
WHERE
key_id = '820979a2d2eb7aed186e9cafd5d68cd63e2e5688d84f5bb05d1a587e3ccbb706'
AND (
token = 'y6vWCdlw5cCSLWzYTpWtP0n4TW0sQpbJo/UatB3ziko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)