UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1GJhrfUS8eXzWBaqiXefn/SIXpKgt0u3JZfPiKzXPE='
WHERE
key_id = '865e17aead74ca4306242d02fc83fad59b1b5572e991582d355de8c7791f5d4f'
AND (
token = 'L1GJhrfUS8eXzWBaqiXefn/SIXpKgt0u3JZfPiKzXPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)