UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'k/OjDJFFptnauom0ZiI+H8TdvW6NWiYeNwWRCF2eCT8=' 
WHERE 
  key_id = 'de773fee2de8ddb0d87fe2e7b18205bc74e127f388d7c28737f392f965dc89fe' 
  AND (
    token = 'k/OjDJFFptnauom0ZiI+H8TdvW6NWiYeNwWRCF2eCT8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022