UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'w/ZclZw3e0+umViCVqFSdY5b7KVcuhxHWk73sy5COrk=' 
WHERE 
  key_id = '244695731ce84148c91a908f9fe45f6bdb309b97a70df78492f2ab233056e5d2' 
  AND (
    token = 'w/ZclZw3e0+umViCVqFSdY5b7KVcuhxHWk73sy5COrk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030