UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CmtyLXOOPDAEQonVzFR7t9r/NpL7jyB8VI9jpIPnWbY=' 
WHERE 
  key_id = '93399ddcb8521598c01a7a7003678bceba40072a0c65b581d4b2ab5ff1e43717' 
  AND (
    token = 'CmtyLXOOPDAEQonVzFR7t9r/NpL7jyB8VI9jpIPnWbY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030