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