UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dCFqSmroZ0wua7QmVLG6ANFljlFiHBXPr2OqELjhSAE='
WHERE
key_id = '65570a46bb769e5e32332effb78a53b72f6e4d9c6f7a341ca13395bca7b5802d'
AND (
token = 'dCFqSmroZ0wua7QmVLG6ANFljlFiHBXPr2OqELjhSAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)