UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9M8wUiCULulCzc/Z27U5BEIUU29qiX2Tu793tv3VuVI='
WHERE
key_id = '4252f6c80da202beb019c5882171377b7e77b5a4f73f944b87510c961a64ab13'
AND (
token = '9M8wUiCULulCzc/Z27U5BEIUU29qiX2Tu793tv3VuVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)