UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iUgr4OksA2kdeK/KHIKGMC9PipuYlSC/HL8omgVTgO4=' 
WHERE 
  key_id = '71b563e89a40bc7f25fef42d3b7302abc08d5163968455404a2a75267ca7ef53' 
  AND (
    token = 'iUgr4OksA2kdeK/KHIKGMC9PipuYlSC/HL8omgVTgO4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024