UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjXlWDJKyzRnVinh9ezrWedb3b0NP0izcNJNENGUkhM='
WHERE
key_id = '06b1d3901b4ab135d0a9cb08cb546f50c3dd366dbe5e2f72b136b62f5e84928a'
AND (
token = 'mjXlWDJKyzRnVinh9ezrWedb3b0NP0izcNJNENGUkhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)