UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpKcC83NzHLqgtIiceBC8QncZyHYbCFSdOQUXyxGjDs='
WHERE
key_id = 'e50cb7628abfda5f973f790943e7e8eb77d96c281d6cf0c450577ac28abd70f5'
AND (
token = 'zpKcC83NzHLqgtIiceBC8QncZyHYbCFSdOQUXyxGjDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)