UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RQQEpf671d4Nv683H9grp6ytnmDiaDaxwy/kV7u1XWo=' 
WHERE 
  key_id = 'febf4f6ba423bb9f519b2b5223218e8012e2ac128beb66cc43351a200c4e969f' 
  AND (
    token = 'RQQEpf671d4Nv683H9grp6ytnmDiaDaxwy/kV7u1XWo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037