UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sqp8yCECfqyW8rQQ5zLiH59k8Fb2QuaNzb/WOaoX/gU='
WHERE
key_id = 'd1a4cb823b48717e0d652d08bf4f71a3f421972332ddf48ffe5bdd0de8bbbd48'
AND (
token = 'sqp8yCECfqyW8rQQ5zLiH59k8Fb2QuaNzb/WOaoX/gU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)