UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LyEqF7n8vPBAAFSrwP/mAPqawcbCbrYEinbkn0fdvwk='
WHERE
key_id = '1c86d965064573e33ea47251c102291fa051d39f3aa66f3b19735b4271dfaa91'
AND (
token = 'LyEqF7n8vPBAAFSrwP/mAPqawcbCbrYEinbkn0fdvwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)