UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ro30MHOul6qc+/4ONMdaE2TXa4KjR7dIRUWDHqKjfRU=' 
WHERE 
  key_id = '05cb3718ff2feee854ad92e35bef9e8947be80431885e2f52fbd2956fe62b788' 
  AND (
    token = 'ro30MHOul6qc+/4ONMdaE2TXa4KjR7dIRUWDHqKjfRU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024