UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WAZX2QTLF0D7usywfp9wfg8wYFy3PMio4lHr49pQ+v0=' 
WHERE 
  key_id = '9fe03557dc4b397161c08f90ea0a41e9bf7951e04de5c7e5fbfb16d71a8077e6' 
  AND (
    token = 'WAZX2QTLF0D7usywfp9wfg8wYFy3PMio4lHr49pQ+v0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039