UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lfA/yW9pcyNRuc4gGwxYGBj5FuPt1qXwI+6PEa+a/KM='
WHERE
key_id = '0578c2d270cfa8cf442707ba2e2e487a32045f45e8c92013a3b74d6f54aba13f'
AND (
token = 'lfA/yW9pcyNRuc4gGwxYGBj5FuPt1qXwI+6PEa+a/KM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)